CREATE TABLE jms_dim.`dim_project_work_order_type` (
  `type_id` bigint  COMMENT '主键',
  `type_desc` string  COMMENT '类型描述',
) COMMENT '项目工单类型表'
PARTITIONED BY (`dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
  stored as parquet
    location '/dw/hive/jms_dim.db/external/dim_project_work_order_type'
    tblproperties (
      'parquet.column.index.access'= 'true'
);